﻿using System;
using System.Collections.Generic;
using System.Web;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
    /// <summary>
    /// Summary description for DA_DM_TRUONG
    /// </summary>
    public class DA_DM_TRUONG : DbObject
    {
        protected SqlConnection connec;
        public DA_DM_TRUONG(SqlConnection Connection)
		{
            connec = Connection;
		}
        public DataSet load_danh_sach_truong(string str_ten_truong)
        {
            SqlParameter[] parameters =  {	 new SqlParameter("@TEN_TRUONG", SqlDbType.NVarChar,100)                               
										 };
            // set the 0values
            parameters[0].Value = str_ten_truong;
            // create the parameter
            DataSet ds_dm_truong = RunProcedure("sp_DM_TRUONG_LoadDSachTruong", parameters, "DM_TRUONG", connec);
            return ds_dm_truong;
        }
    }
}